﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_PROJECTS_IN')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_PROJECTS_IN
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_USER_PROJECTS_IN] 
(
    @TUP_USER_ID Integer,
    @TUP_PROJECT Varchar(80) )
AS
	INSERT INTO TB_USER_PROJECTS
	(TUP_USER_ID,TUP_PROJECT)
	values
	(@TUP_USER_ID,@TUP_PROJECT)


GO

GRANT EXEC ON dbo.PRC_TB_USER_PROJECTS_IN TO PUBLIC

GO

